Alphabetical Language Reference

The DQL Lexicon is a complete list of all the DataEase Query Language concepts, terms, and symbols presented in alphabetical order. In this lexicon, most entries begin on a separate page. However, some entries continue for two or more pages. Each term is explained in the following format (only relevant sections are included):

Type

Identifies the type of the term. DQL terms are divided into four main groups: commands, functions, operators, and symbols. Each of these groups contains several subordinate types.

Purpose

Explains the general purpose of the term.

Syntax

Demonstrates the proper format in which the term is used. For an explanation of the syntax format itself, see Typographical Conventions later in this chapter.

Returns

Specifies the type of value returned by a function or operator.

Usage

Provides additional details concerning the use of the term in general and special contexts.

LAN

Includes special considerations or restrictions that govern the use of the term when DataEase is running on a LAN (Local Area Network).

Example

Demonstrates the use of the term in a DQL statement or script. When a complete script is presented, an explanation of the script is included. If the script generates output, an example of how the resulting output might appear is included (see example below).

A list appears in the right margin showing where you can use a DQL keyword. For example, the figure below shows the lists for the count of and commit commands.